To delete a custom table
- Make sure all other users exit the iMIS system.
- Back up your data.
- Log into iMIS as the database owner: MANAGER!SA (Sybase: MANAGER!DBA)
- From Customers, select Set up module> General, and click Additional Windows to open the Customer Setup – Additional Windows window.
- Click Define Tables to open the User Defined Tables window.
- Select the table you want to delete from the Table Name drop-down list.
- Click Delete. iMIS prompts you to confirm the deletion.
- Click Yes to delete the table.
- Click Cancel to close the User Defined Tables window.
- Select Utilities> Table Analysis.
- Select the user-defined or custom table that was deleted. Click Drop Table.
- Click Yes when the confirmation message to drop the table displays. The Notes field displays the following message: Table does not exist on server. Although the table and the data within the data still exist, this information is no longer available.
- Exit iMIS immediately.
- Refresh the iMIS libraries by replacing the existing imismem.lbr and imisutil.lbr files with a clean copy of these files.
Note: If you copy the library files from a CD, make sure to disable the Read only option.
10.6 Production Release. Updated 2/21/2006 12:39:48 PM
Copyright © by Advanced Solutions International, Inc.
All rights reserved.